Application of data warehouse technology in power analysis
نویسندگان
چکیده
Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensional database modeling and the presentation of multidimensional views. The system also builds power-oriented data warehouse using DB2 database, Warehouse Manager, Cube View and Alphablox of IBM. Then, this paper discusses the concrete applications of data warehouse in completing the extract, transform and load (ETL) of power data. The discussion includes the optimization of the system after creating the MQT tables using Cube View and the presentation of the analysis system. The system can help power corporations to do the decision-making.
منابع مشابه
Abstract: Data warehouse technology transforms the operational data store to general and compositive information
Data warehouse technology transforms the operational data store to general and compositive information. It also provides effective way for analysis and statistic to the mass data, and helps to do the decision-making. The paper introduces the data warehouse and the online analysis process. According to the power management information system, the paper analyzes the power-oriented multidimensiona...
متن کاملA Solution to View Management to Build a Data Warehouse
Several techniques exist to select and materialize a proper set of data in a suitable structure that manage the queries submitted to the online analytical processing systems. These techniques are called view management techniques, which consist of three research areas: 1) view selection to materialize, 2) query processing and rewriting using the materialized views, and 3) maintaining materializ...
متن کاملApplication of Big Data Analytics in Power Distribution Network
Smart grid enhances optimization in generation, distribution and consumption of the electricity by integrating information and communication technologies into the grid. Today, utilities are moving towards smart grid applications, most common one being deployment of smart meters in advanced metering infrastructure, and the first technical challenge they face is the huge volume of data generated ...
متن کاملNon-linear modeling, analysis, design and simulation of a solid state power amplifier based on GaN technology for Ku band microwave application
A new non-linear method for design and analysis of solid state power amplifiers is presented and applied to an aluminum gallium nitride, gallium nitride (AlGaN-GaN) high electron-mobility transistor (HEMTs) on silicon-carbide (SiC) substrate for Ku band (12.4 13.6 GHz) applications. With combining output power of 8 transistors, maximum output power of 46.3 dBm (42.6 W), PAE of 43% and linear ga...
متن کاملData Warehouse Design and Optimization for Drilling Engineering
With the development of petroleum informatization and increase of drilling data, data storage, analysis and integration is attached to the key planning process. Therefore, a solution is needed which combines the data integration, management, analysis and decision support. Data warehouse is one of the hot topics in computer technology application, which has solved the problem of data using after...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2006